Stored Procedures [dbo].[BAEGetExistingLineTotal]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEGetExistingLineTotal
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@orderNumint4
SQL Script
create procedure [dbo].[BAEGetExistingLineTotal] @orderNum int as
SELECT LINE_TOTAL FROM Orders WHERE ORDER_NUMBER = @orderNum

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved